Overview

Brought to you by YData

Dataset statistics

Number of variables	46
Number of observations	109656
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2764
Duplicate rows (%)	2.5%
Total size in memory	110.3 MiB
Average record size in memory	1.0 KiB

Variable types

Unsupported	11
Numeric	15
Categorical	20

Alerts

Dataset has 2764 (2.5%) duplicate rows	Duplicates
`DayOfWeek_AtEntry` is highly overall correlated with `Is_Weekend` and 1 other fields	High correlation
`HourOfDay_AtEntry` is highly overall correlated with `Off_Hours_Entry` and 3 other fields	High correlation
`InsuranceCategory` is highly overall correlated with `MMS_Flag` and 1 other fields	High correlation
`Insurance_Coverage_Ratio` is highly overall correlated with `Rx_TotalInsPaid` and 2 other fields	High correlation
`Is_Weekend` is highly overall correlated with `DayOfWeek_AtEntry` and 1 other fields	High correlation
`MMS_Flag` is highly overall correlated with `InsuranceCategory` and 2 other fields	High correlation
`MMS_Flagged` is highly overall correlated with `InsuranceCategory` and 2 other fields	High correlation
`Multiple_Issues` is highly overall correlated with `MMS_Flag` and 1 other fields	High correlation
`Off_Hours_Entry` is highly overall correlated with `HourOfDay_AtEntry` and 2 other fields	High correlation
`PeakHoursIndicator_AtEntry` is highly overall correlated with `HourOfDay_AtEntry` and 3 other fields	High correlation
`Peak_Hours_Rejection` is highly overall correlated with `HourOfDay_AtEntry` and 3 other fields	High correlation
`PrescriptionsPerStaff_AtEntry` is highly overall correlated with `Rx_RxEntered_By` and 1 other fields	High correlation
`Price_vs_Total_Ratio` is highly overall correlated with `Rx_Total_Price`	High correlation
`Rx_Days_Supply_Filed` is highly overall correlated with `Rx_Quantity_Filled`	High correlation
`Rx_Quantity_Filled` is highly overall correlated with `Rx_Days_Supply_Filed`	High correlation
`Rx_RxEntered_By` is highly overall correlated with `Off_Hours_Entry` and 5 other fields	High correlation
`Rx_TotalInsPaid` is highly overall correlated with `Insurance_Coverage_Ratio` and 1 other fields	High correlation
`Rx_TotalRxAmount` is highly overall correlated with `Insurance_Coverage_Ratio` and 1 other fields	High correlation
`Rx_Total_Price` is highly overall correlated with `Price_vs_Total_Ratio`	High correlation
`StaffVolume_AtEntry` is highly overall correlated with `PrescriptionsPerStaff_AtEntry` and 1 other fields	High correlation
`Time_Category` is highly overall correlated with `HourOfDay_AtEntry` and 4 other fields	High correlation
`Weekend_Rejection` is highly overall correlated with `DayOfWeek_AtEntry` and 1 other fields	High correlation
`Zero_Insurance_Payment` is highly overall correlated with `Insurance_Coverage_Ratio`	High correlation
`InsuranceCategory` is highly imbalanced (65.0%)	Imbalance
`MMS_Flag` is highly imbalanced (68.2%)	Imbalance
`Rx_Is_non_Rx?` is highly imbalanced (97.1%)	Imbalance
`Rx_PRN?` is highly imbalanced (97.8%)	Imbalance
`DAW_Required` is highly imbalanced (89.1%)	Imbalance
`MMS_Flagged` is highly imbalanced (68.2%)	Imbalance
`Multiple_Issues` is highly imbalanced (76.1%)	Imbalance
`New_Patient_High_Value` is highly imbalanced (88.3%)	Imbalance
`Rx_Quantity_Filled` is highly skewed (γ1 = 24.53137116)	Skewed
`Rx_Total_Price` is highly skewed (γ1 = 91.40968528)	Skewed
`Rx_TotalInsPaid` is highly skewed (γ1 = 32.77645565)	Skewed
`Rx_TotalRxAmount` is highly skewed (γ1 = 91.95428609)	Skewed
`Price_vs_Total_Ratio` is highly skewed (γ1 = -107.6952337)	Skewed
`Rx RxEntered Date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Insurance_Carrier_Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Insurance_Accepts_Assignments` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Insurance_Billing_Receiver_ID` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MainRejectCode` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MainRejectDescription` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Rx_Status` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Rx_Hold_Rx_(Checkbox)` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Rx_DAW` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Rx_Discontinued?` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Rx_DUR_Entered_?` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DayOfWeek_AtEntry` has 15696 (14.3%) zeros	Zeros
`HourOfDay_AtEntry` has 1955 (1.8%) zeros	Zeros
`Rx_Days_Supply_Filed` has 22895 (20.9%) zeros	Zeros
`Rx_Quantity_Filled` has 22915 (20.9%) zeros	Zeros
`Rx_Total_Price` has 1552 (1.4%) zeros	Zeros
`Rx_TotalInsPaid` has 29374 (26.8%) zeros	Zeros
`Rx_Refills_Remaining` has 54019 (49.3%) zeros	Zeros
`Insurance_Coverage_Ratio` has 29374 (26.8%) zeros	Zeros
`Price_vs_Total_Ratio` has 1552 (1.4%) zeros	Zeros
`PatientTenureDays` has 19070 (17.4%) zeros	Zeros

Reproduction

Analysis started	2025-09-16 22:04:49.786645
Analysis finished	2025-09-16 22:05:11.615538
Duration	21.83 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Rx RxEntered Date
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	7.2 MiB

DayOfWeek_AtEntry
Real number (ℝ)

High correlation Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6993689

Minimum	0
Maximum	6
Zeros	15696
Zeros (%)	14.3%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.8091651
Coefficient of variation (CV)	0.67021779
Kurtosis	-0.95825845
Mean	2.6993689
Median Absolute Deviation (MAD)	1
Skewness	0.15365031
Sum	296002
Variance	3.2730783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	22548	20.6%
2	18476	16.8%
1	16636	15.2%
0	15696	14.3%
4	15493	14.1%
5	12044	11.0%
6	8763	8.0%

Value	Count	Frequency (%)
0	15696	14.3%
1	16636	15.2%
2	18476	16.8%
3	22548	20.6%
4	15493	14.1%
5	12044	11.0%
6	8763	8.0%

Value	Count	Frequency (%)
6	8763	8.0%
5	12044	11.0%
4	15493	14.1%
3	22548	20.6%
2	18476	16.8%
1	16636	15.2%
0	15696	14.3%

DayOfMonth_AtEntry
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.217954

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	15
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.0062264
Coefficient of variation (CV)	0.59181584
Kurtosis	-1.3079114
Mean	15.217954
Median Absolute Deviation (MAD)	9
Skewness	0.1057956
Sum	1668740
Variance	81.112114
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
5	13109	12.0%
4	5628	5.1%
18	3978	3.6%
22	3969	3.6%
29	3652	3.3%
27	3640	3.3%
24	3569	3.3%
28	3553	3.2%
15	3548	3.2%
23	3533	3.2%
Other values (21)	61477	56.1%

Value	Count	Frequency (%)
1	2536	2.3%
2	2695	2.5%
3	2665	2.4%
4	5628	5.1%
5	13109	12.0%
6	2787	2.5%
7	2380	2.2%
8	2818	2.6%
9	2658	2.4%
10	3074	2.8%

Value	Count	Frequency (%)
31	1939	1.8%
30	3385	3.1%
29	3652	3.3%
28	3553	3.2%
27	3640	3.3%
26	2997	2.7%
25	3198	2.9%
24	3569	3.3%
23	3533	3.2%
22	3969	3.6%

HourOfDay_AtEntry
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.442529

Minimum	0
Maximum	23
Zeros	1955
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	11
Q3	14
95-th percentile	17
Maximum	23
Range	23
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	5.0244052
Coefficient of variation (CV)	0.48114829
Kurtosis	-0.57923217
Mean	10.442529
Median Absolute Deviation (MAD)	3
Skewness	-0.47314267
Sum	1145086
Variance	25.244647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
3	17366	15.8%
11	10532	9.6%
10	10187	9.3%
12	10117	9.2%
9	9745	8.9%
15	9583	8.7%
14	9427	8.6%
13	9259	8.4%
16	8876	8.1%
1	4548	4.1%
Other values (14)	10016	9.1%

Value	Count	Frequency (%)
0	1955	1.8%
1	4548	4.1%
2	368	0.3%
3	17366	15.8%
4	184	0.2%
5	295	0.3%
6	333	0.3%
7	224	0.2%
8	678	0.6%
9	9745	8.9%

Value	Count	Frequency (%)
23	506	0.5%
22	408	0.4%
21	394	0.4%
20	384	0.4%
19	520	0.5%
18	1079	1.0%
17	2688	2.5%
16	8876	8.1%
15	9583	8.7%
14	9427	8.6%

PeakHoursIndicator_AtEntry
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	71641
1	38015

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring characters

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

PatientVisitFrequency
Real number (ℝ)

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9221292

Minimum	1
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	26
Range	25
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.6986936
Coefficient of variation (CV)	0.88375618
Kurtosis	15.487258
Mean	1.9221292
Median Absolute Deviation (MAD)	0
Skewness	3.3092987
Sum	210773
Variance	2.8855598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
1	64503	58.8%
2	22311	20.3%
3	11621	10.6%
4	4128	3.8%
5	2192	2.0%
6	1707	1.6%
7	929	0.8%
8	654	0.6%
9	532	0.5%
10	372	0.3%
Other values (16)	707	0.6%

Value	Count	Frequency (%)
1	64503	58.8%
2	22311	20.3%
3	11621	10.6%
4	4128	3.8%
5	2192	2.0%
6	1707	1.6%
7	929	0.8%
8	654	0.6%
9	532	0.5%
10	372	0.3%

Value	Count	Frequency (%)
26	1	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
21	3	< 0.1%
20	3	< 0.1%
19	4	< 0.1%
18	6	< 0.1%
17	9	< 0.1%

IsNewPatient
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	92821
1	16835

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Most occurring characters

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	92821	84.6%
1	16835	15.4%

Rx_Days_Supply_Filed
Real number (ℝ)

High correlation Zeros

Distinct	122
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.581902

Minimum	0
Maximum	365
Zeros	22895
Zeros (%)	20.9%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	25
Q3	30
95-th percentile	90
Maximum	365
Range	365
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	30.520824
Coefficient of variation (CV)	0.96640235
Kurtosis	4.1836461
Mean	31.581902
Median Absolute Deviation (MAD)	5
Skewness	1.4602884
Sum	3463145
Variance	931.52068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	25500	23.3%
25	23226	21.2%
0	22895	20.9%
90	17245	15.7%
28	6412	5.8%
1	2280	2.1%
10	1371	1.3%
7	1368	1.2%
5	1322	1.2%
15	955	0.9%
Other values (112)	7082	6.5%

Value	Count	Frequency (%)
0	22895	20.9%
1	2280	2.1%
2	151	0.1%
3	206	0.2%
4	143	0.1%
5	1322	1.2%
6	253	0.2%
7	1368	1.2%
8	122	0.1%
9	44	< 0.1%

Value	Count	Frequency (%)
365	18	< 0.1%
364	1	< 0.1%
360	6	< 0.1%
353	1	< 0.1%
300	4	< 0.1%
270	1	< 0.1%
267	1	< 0.1%
250	1	< 0.1%
240	1	< 0.1%
233	1	< 0.1%

Rx_Quantity_Filled
Real number (ℝ)

High correlation Skewed Zeros

Distinct	279
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.017324

Minimum	0
Maximum	5688
Zeros	22915
Zeros (%)	20.9%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	10
Q3	60
95-th percentile	120
Maximum	5688
Range	5688
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	92.063867
Coefficient of variation (CV)	2.3006003
Kurtosis	1020.7469
Mean	40.017324
Median Absolute Deviation (MAD)	10
Skewness	24.531371
Sum	4388139.7
Variance	8475.7556
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	23712	21.6%
0	22915	20.9%
30	13341	12.2%
90	13030	11.9%
60	5339	4.9%
100	3845	3.5%
180	2938	2.7%
28	2748	2.5%
1	1910	1.7%
15	1234	1.1%
Other values (269)	18644	17.0%

Value	Count	Frequency (%)
0	22915	20.9%
0.2	115	0.1%
0.24	2	< 0.1%
0.25	305	0.3%
0.3	762	0.7%
0.4	4	< 0.1%
0.42	2	< 0.1%
0.5	462	0.4%
0.7	4	< 0.1%
1	1910	1.7%

Value	Count	Frequency (%)
5688	1	< 0.1%
4000	27	< 0.1%
3784	1	< 0.1%
2365	3	< 0.1%
1800	1	< 0.1%
1620	1	< 0.1%
1440	2	< 0.1%
1419	1	< 0.1%
1350	14	< 0.1%
1182.8	1	< 0.1%

InsuranceCategory
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

Private Insurance Carrier	98701
Public Insurance Carrier	7887
Private Patient	3068

Length

Max length	25
Median length	25
Mean length	24.648291
Min length	15

Characters and Unicode

Total characters	2702833
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private Insurance Carrier
2nd row	Public Insurance Carrier
3rd row	Public Insurance Carrier
4th row	Public Insurance Carrier
5th row	Private Insurance Carrier

Common Values

Value	Count	Frequency (%)
Private Insurance Carrier	98701	90.0%
Public Insurance Carrier	7887	7.2%
Private Patient	3068	2.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
insurance	106588	32.7%
carrier	106588	32.7%
private	101769	31.2%
public	7887	2.4%
patient	3068	0.9%

Most occurring characters

Value	Count	Frequency (%)
r	528121	19.5%
a	318013	11.8%
e	318013	11.8%
i	219312	8.1%
	216244	8.0%
n	216244	8.0%
u	114475	4.2%
c	114475	4.2%
P	112724	4.2%
t	107905	4.0%
Other values (6)	437307	16.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2702833	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	528121	19.5%
a	318013	11.8%
e	318013	11.8%
i	219312	8.1%
	216244	8.0%
n	216244	8.0%
u	114475	4.2%
c	114475	4.2%
P	112724	4.2%
t	107905	4.0%
Other values (6)	437307	16.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2702833	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	528121	19.5%
a	318013	11.8%
e	318013	11.8%
i	219312	8.1%
	216244	8.0%
n	216244	8.0%
u	114475	4.2%
c	114475	4.2%
P	112724	4.2%
t	107905	4.0%
Other values (6)	437307	16.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2702833	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	528121	19.5%
a	318013	11.8%
e	318013	11.8%
i	219312	8.1%
	216244	8.0%
n	216244	8.0%
u	114475	4.2%
c	114475	4.2%
P	112724	4.2%
t	107905	4.0%
Other values (6)	437307	16.2%

Insurance_Carrier_Code
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	5.5 MiB

Insurance_Accepts_Assignments
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	5.6 MiB

Insurance_Billing_Receiver_ID
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

MMS_Flag
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	103323
1	6333

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring characters

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Rx_Total_Price
Real number (ℝ)

High correlation Skewed Zeros

Distinct	9293
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.52945

Minimum	-5
Maximum	139500
Zeros	1552
Zeros (%)	1.4%
Negative	14
Negative (%)	< 0.1%
Memory size	856.8 KiB

Quantile statistics

Minimum	-5
5-th percentile	0.08
Q1	0.16
median	7.5
Q3	40.6475
95-th percentile	569.92
Maximum	139500
Range	139505
Interquartile range (IQR)	40.4875

Descriptive statistics

Standard deviation	689.67532
Coefficient of variation (CV)	5.9696929
Kurtosis	15867.971
Mean	115.52945
Median Absolute Deviation (MAD)	7.42
Skewness	91.409685
Sum	12668497
Variance	475652.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.08	25339	23.1%
0	1552	1.4%
10	1135	1.0%
400	766	0.7%
5	678	0.6%
15	562	0.5%
12	442	0.4%
8	395	0.4%
9	393	0.4%
255.01	390	0.4%
Other values (9283)	78004	71.1%

Value	Count	Frequency (%)
-5	3	< 0.1%
-1	2	< 0.1%
-0.11	9	< 0.1%
0	1552	1.4%
0.01	96	0.1%
0.02	4	< 0.1%
0.03	1	< 0.1%
0.04	15	< 0.1%
0.05	4	< 0.1%
0.06	29	< 0.1%

Value	Count	Frequency (%)
139500	1	< 0.1%
48000	1	< 0.1%
33192.6	3	< 0.1%
32785.2	1	< 0.1%
26790.76	1	< 0.1%
25312.5	1	< 0.1%
25200	1	< 0.1%
25040	1	< 0.1%
22799.39	1	< 0.1%
21641.94	2	< 0.1%

Rx_TotalInsPaid
Real number (ℝ)

High correlation Skewed Zeros

Distinct	9678
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133.33582

Minimum	-173.04
Maximum	48005
Zeros	29374
Zeros (%)	26.8%
Negative	171
Negative (%)	0.2%
Memory size	856.8 KiB

Quantile statistics

Minimum	-173.04
5-th percentile	0
Q1	0
median	23.55
Q3	94.08
95-th percentile	570.83
Maximum	48005
Range	48178.04
Interquartile range (IQR)	94.08

Descriptive statistics

Standard deviation	524.59457
Coefficient of variation (CV)	3.9343858
Kurtosis	1748.3938
Mean	133.33582
Median Absolute Deviation (MAD)	23.55
Skewness	32.776456
Sum	14621073
Variance	275199.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29374	26.8%
94.08	25353	23.1%
40	1043	1.0%
405	725	0.7%
0.34	645	0.6%
199.93	275	0.3%
67.83	223	0.2%
112	167	0.2%
1.4	150	0.1%
10	143	0.1%
Other values (9668)	51558	47.0%

Value	Count	Frequency (%)
-173.04	1	< 0.1%
-94.18	1	< 0.1%
-80.06	1	< 0.1%
-75.12	1	< 0.1%
-37.02	1	< 0.1%
-33.01	1	< 0.1%
-11.29	1	< 0.1%
-10	1	< 0.1%
-9.95	1	< 0.1%
-9.66	1	< 0.1%

Value	Count	Frequency (%)
48005	1	< 0.1%
33197.6	2	< 0.1%
32790.2	1	< 0.1%
26795.76	1	< 0.1%
25317.5	1	< 0.1%
25205	1	< 0.1%
22801.39	1	< 0.1%
22133.88	1	< 0.1%
21646.94	1	< 0.1%
21645	7	< 0.1%

Rx_TotalRxAmount
Real number (ℝ)

High correlation Skewed

Distinct	10004
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	144.95787

Minimum	0
Maximum	139500
Zeros	338
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1.46
Q1	7.67
median	39.44
Q3	94.08
95-th percentile	593.06
Maximum	139500
Range	139500
Interquartile range (IQR)	86.41

Descriptive statistics

Standard deviation	687.62255
Coefficient of variation (CV)	4.7436028
Kurtosis	16039.19
Mean	144.95787
Median Absolute Deviation (MAD)	37.64
Skewness	91.954286
Sum	15895500
Variance	472824.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94.08	25354	23.1%
10	1155	1.1%
40	1100	1.0%
405	727	0.7%
15	685	0.6%
5	680	0.6%
12	604	0.6%
8	404	0.4%
250.93	354	0.3%
0	338	0.3%
Other values (9994)	78255	71.4%

Value	Count	Frequency (%)
0	338	0.3%
0.01	82	0.1%
0.03	1	< 0.1%
0.05	1	< 0.1%
0.07	2	< 0.1%
0.1	20	< 0.1%
0.11	1	< 0.1%
0.12	28	< 0.1%
0.13	30	< 0.1%
0.14	45	< 0.1%

Value	Count	Frequency (%)
139500	1	< 0.1%
48005	1	< 0.1%
33197.6	2	< 0.1%
33192.6	1	< 0.1%
32790.2	1	< 0.1%
26795.76	1	< 0.1%
25317.5	1	< 0.1%
25205	1	< 0.1%
25040	1	< 0.1%
22801.39	1	< 0.1%

Rx_RxEntered_By
Categorical

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

RS	32168
MMS	17376
TS	16835
MKHAN	8521
MNK	8249
Other values (42)	26507

Length

Max length	5
Median length	2
Mean length	2.5231178
Min length	2

Characters and Unicode

Total characters	276675
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	RS
2nd row	RS
3rd row	RS
4th row	RS
5th row	RS

Common Values

Value	Count	Frequency (%)
RS	32168	29.3%
MMS	17376	15.8%
TS	16835	15.4%
MKHAN	8521	7.8%
MNK	8249	7.5%
FS	6408	5.8%
EA	4410	4.0%
DP	2277	2.1%
UM	2193	2.0%
PP	1349	1.2%
Other values (37)	9870	9.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rs	32168	29.3%
mms	17376	15.8%
ts	16835	15.4%
mkhan	8521	7.8%
mnk	8249	7.5%
fs	6408	5.8%
ea	4410	4.0%
dp	2277	2.1%
um	2193	2.0%
pp	1349	1.2%
Other values (37)	9870	9.0%

Most occurring characters

Value	Count	Frequency (%)
S	74950	27.1%
M	58163	21.0%
R	34768	12.6%
K	18429	6.7%
T	17649	6.4%
N	17475	6.3%
A	15124	5.5%
H	11011	4.0%
F	6408	2.3%
P	5149	1.9%
Other values (12)	17549	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	276675	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	74950	27.1%
M	58163	21.0%
R	34768	12.6%
K	18429	6.7%
T	17649	6.4%
N	17475	6.3%
A	15124	5.5%
H	11011	4.0%
F	6408	2.3%
P	5149	1.9%
Other values (12)	17549	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	276675	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	74950	27.1%
M	58163	21.0%
R	34768	12.6%
K	18429	6.7%
T	17649	6.4%
N	17475	6.3%
A	15124	5.5%
H	11011	4.0%
F	6408	2.3%
P	5149	1.9%
Other values (12)	17549	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	276675	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	74950	27.1%
M	58163	21.0%
R	34768	12.6%
K	18429	6.7%
T	17649	6.4%
N	17475	6.3%
A	15124	5.5%
H	11011	4.0%
F	6408	2.3%
P	5149	1.9%
Other values (12)	17549	6.3%

PrescriptionsPerStaff_AtEntry
Real number (ℝ)

High correlation

Distinct	173
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	378.06066

Minimum	1
Maximum	5501
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	20
median	37
Q3	133
95-th percentile	5501
Maximum	5501
Range	5500
Interquartile range (IQR)	113

Descriptive statistics

Standard deviation	1189.0199
Coefficient of variation (CV)	3.1450506
Kurtosis	14.29426
Mean	378.06066
Median Absolute Deviation (MAD)	23
Skewness	3.9945881
Sum	41456620
Variance	1413768.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5501	5501	5.0%
24	2401	2.2%
23	1933	1.8%
27	1918	1.7%
22	1893	1.7%
16	1888	1.7%
29	1828	1.7%
19	1826	1.7%
12	1778	1.6%
15	1756	1.6%
Other values (163)	86934	79.3%

Value	Count	Frequency (%)
1	467	0.4%
2	760	0.7%
3	849	0.8%
4	1034	0.9%
5	1055	1.0%
6	1350	1.2%
7	1421	1.3%
8	1464	1.3%
9	1315	1.2%
10	1631	1.5%

Value	Count	Frequency (%)
5501	5501	5.0%
858	858	0.8%
713	713	0.7%
702	702	0.6%
688	688	0.6%
590	590	0.5%
579	579	0.5%
556	556	0.5%
553	553	0.5%
502	502	0.5%

StaffVolume_AtEntry
Real number (ℝ)

High correlation

Distinct	173
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	342.63136

Minimum	1
Maximum	5501
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	13
median	27
Q3	86
95-th percentile	5501
Maximum	5501
Range	5500
Interquartile range (IQR)	73

Descriptive statistics

Standard deviation	1190.4229
Coefficient of variation (CV)	3.4743547
Kurtosis	14.692087
Mean	342.63136
Median Absolute Deviation (MAD)	17
Skewness	4.0667987
Sum	37571584
Variance	1417106.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5501	5501	5.0%
13	2977	2.7%
12	2472	2.3%
8	2464	2.2%
11	2464	2.2%
9	2421	2.2%
6	2388	2.2%
14	2296	2.1%
15	2265	2.1%
17	2261	2.1%
Other values (163)	82147	74.9%

Value	Count	Frequency (%)
1	1070	1.0%
2	1600	1.5%
3	1893	1.7%
4	2028	1.8%
5	2090	1.9%
6	2388	2.2%
7	2184	2.0%
8	2464	2.2%
9	2421	2.2%
10	2050	1.9%

Value	Count	Frequency (%)
5501	5501	5.0%
590	590	0.5%
553	553	0.5%
502	502	0.5%
501	501	0.5%
473	473	0.4%
452	452	0.4%
430	430	0.4%
383	383	0.3%
360	360	0.3%

MainRejectCode
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

MainRejectDescription
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

Rx_Status
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

Rx_Hold_Rx_(Checkbox)
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	3.8 MiB

Rx_Is_non_Rx?
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	109333
1	323

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	109333	99.7%
1	323	0.3%

Rx_PRN?
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	109427
1	229

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	109427	99.8%
1	229	0.2%

Rx_DAW
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

Rx_Discontinued?
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	3.8 MiB

Rx_DUR_Entered_?
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

Rx_Refills_Remaining
Real number (ℝ)

Zeros

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7894871

Minimum	-2
Maximum	99
Zeros	54019
Zeros (%)	49.3%
Negative	14
Negative (%)	< 0.1%
Memory size	856.8 KiB

Quantile statistics

Minimum	-2
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	99
Range	101
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	7.4186178
Coefficient of variation (CV)	4.145667
Kurtosis	152.39636
Mean	1.7894871
Median Absolute Deviation (MAD)	1
Skewness	12.101591
Sum	196228
Variance	55.03589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	54019	49.3%
3	18404	16.8%
2	16003	14.6%
1	15681	14.3%
4	1343	1.2%
5	999	0.9%
6	564	0.5%
11	490	0.4%
10	429	0.4%
8	329	0.3%
Other values (22)	1395	1.3%

Value	Count	Frequency (%)
-2	4	< 0.1%
-1	10	< 0.1%
0	54019	49.3%
1	15681	14.3%
2	16003	14.6%
3	18404	16.8%
4	1343	1.2%
5	999	0.9%
6	564	0.5%
7	315	0.3%

Value	Count	Frequency (%)
99	263	0.2%
98	110	0.1%
97	55	0.1%
96	44	< 0.1%
95	43	< 0.1%
94	40	< 0.1%
93	22	< 0.1%
92	16	< 0.1%
91	12	< 0.1%
90	11	< 0.1%

Insurance_Coverage_Ratio
Real number (ℝ)

High correlation Zeros

Distinct	12822
Distinct (%)	11.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.69038025

Minimum	-5.5192878
Maximum	0.99999998
Zeros	29374
Zeros (%)	26.8%
Negative	171
Negative (%)	0.2%
Memory size	856.8 KiB

Quantile statistics

Minimum	-5.5192878
5-th percentile	0
Q1	0
median	0.99986074
Q3	0.99998937
95-th percentile	0.999998
Maximum	0.99999998
Range	6.5192878
Interquartile range (IQR)	0.99998937

Descriptive statistics

Standard deviation	0.45122639
Coefficient of variation (CV)	0.6535911
Kurtosis	0.94493662
Mean	0.69038025
Median Absolute Deviation (MAD)	0.00013750469
Skewness	-1.0757892
Sum	75704.337
Variance	0.20360526
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	29374	26.8%
0.999989371	25353	23.1%
0.9999750006	1043	1.0%
0.9999975309	725	0.7%
0.796752892	275	0.3%
0.9999852575	223	0.2%
0.999991072	167	0.2%
0.9992862241	149	0.1%
0.99990001	131	0.1%
0.9999389164	121	0.1%
Other values (12812)	52095	47.5%

Value	Count	Frequency (%)
-5.519287834	1	< 0.1%
-5.15444878	1	< 0.1%
-4.745545443	1	< 0.1%
-4.460303301	1	< 0.1%
-4.064770348	1	< 0.1%
-3.137606455	2	< 0.1%
-2.932895354	1	< 0.1%
-2.83286119	1	< 0.1%
-2.740348221	5	< 0.1%
-2.739383847	4	< 0.1%

Value	Count	Frequency (%)
0.9999999792	1	< 0.1%
0.9999999699	2	< 0.1%
0.9999999695	1	< 0.1%
0.9999999627	1	< 0.1%
0.9999999605	1	< 0.1%
0.9999999603	1	< 0.1%
0.9999999561	1	< 0.1%
0.999999955	1	< 0.1%
0.9999999538	1	< 0.1%
0.9999999538	7	< 0.1%

Price_vs_Total_Ratio
Real number (ℝ)

High correlation Skewed Zeros

Distinct	16000
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.61568044

Minimum	-5000
Maximum	4315.5119
Zeros	1552
Zeros (%)	1.4%
Negative	14
Negative (%)	< 0.1%
Memory size	856.8 KiB

Quantile statistics

Minimum	-5000
5-th percentile	0.000850331
Q1	0.074060359
median	0.9883806
Q3	0.99986757
95-th percentile	0.99999443
Maximum	4315.5119
Range	9315.5119
Interquartile range (IQR)	0.92580721

Descriptive statistics

Standard deviation	29.226124
Coefficient of variation (CV)	47.469633
Kurtosis	27779.099
Mean	0.61568044
Median Absolute Deviation (MAD)	0.011610756
Skewness	-107.69523
Sum	67513.054
Variance	854.16635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.000850331	25323	23.1%
0	1552	1.4%
0.99990001	1039	0.9%
0.9876518823	727	0.7%
0.99980004	635	0.6%
0.9999333378	525	0.5%
0.9999166736	429	0.4%
0.9998750156	388	0.4%
1.016255465	354	0.3%
0.9997500625	291	0.3%
Other values (15990)	78393	71.5%

Value	Count	Frequency (%)
-5000	3	< 0.1%
-0.249937516	2	< 0.1%
-0.022490288	9	< 0.1%
0	1552	1.4%
5.55521607 × 10^-5	1	< 0.1%
6.249570342 × 10^-5	1	< 0.1%
9.998900121 × 10^-5	4	< 0.1%
0.000111098	1	< 0.1%
0.000133315	3	< 0.1%
0.000249931	2	< 0.1%

Value	Count	Frequency (%)
4315.511868	1	< 0.1%
46.76612935	2	< 0.1%
20.87136929	1	< 0.1%
14.85543901	1	< 0.1%
11.69043722	1	< 0.1%
9.573836346	1	< 0.1%
9.12868092	1	< 0.1%
6.989659567	1	< 0.1%
6.165099269	1	< 0.1%
4.567770804	1	< 0.1%

Zero_Insurance_Payment
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	80282
1	29374

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

Most occurring characters

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	80282	73.2%
1	29374	26.8%

High_Value_Rx
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	82518
1	27138

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Most occurring characters

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	82518	75.3%
1	27138	24.7%

Is_Weekend
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	85197
1	24459

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring characters

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Time_Category
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.7 MiB

Morning	41483
Afternoon	40912
Night	25049
Evening	2212

Length

Max length	9
Median length	7
Mean length	7.289323
Min length	5

Characters and Unicode

Total characters	799318
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Evening
2nd row	Morning
3rd row	Afternoon
4th row	Afternoon
5th row	Morning

Common Values

Value	Count	Frequency (%)
Morning	41483	37.8%
Afternoon	40912	37.3%
Night	25049	22.8%
Evening	2212	2.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
morning	41483	37.8%
afternoon	40912	37.3%
night	25049	22.8%
evening	2212	2.0%

Most occurring characters

Value	Count	Frequency (%)
n	169214	21.2%
o	123307	15.4%
r	82395	10.3%
i	68744	8.6%
g	68744	8.6%
t	65961	8.3%
e	43124	5.4%
M	41483	5.2%
A	40912	5.1%
f	40912	5.1%
Other values (4)	54522	6.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	799318	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	169214	21.2%
o	123307	15.4%
r	82395	10.3%
i	68744	8.6%
g	68744	8.6%
t	65961	8.3%
e	43124	5.4%
M	41483	5.2%
A	40912	5.1%
f	40912	5.1%
Other values (4)	54522	6.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	799318	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	169214	21.2%
o	123307	15.4%
r	82395	10.3%
i	68744	8.6%
g	68744	8.6%
t	65961	8.3%
e	43124	5.4%
M	41483	5.2%
A	40912	5.1%
f	40912	5.1%
Other values (4)	54522	6.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	799318	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	169214	21.2%
o	123307	15.4%
r	82395	10.3%
i	68744	8.6%
g	68744	8.6%
t	65961	8.3%
e	43124	5.4%
M	41483	5.2%
A	40912	5.1%
f	40912	5.1%
Other values (4)	54522	6.8%

Off_Hours_Entry
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	82171
1	27485

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

Most occurring characters

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	82171	74.9%
1	27485	25.1%

DAW_Required
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	108066
1	1590

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

Most occurring characters

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	108066	98.6%
1	1590	1.4%

IsRefill
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	64551
1	45105

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

Most occurring characters

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	64551	58.9%
1	45105	41.1%

PatientTenureDays
Real number (ℝ)

Zeros

Distinct	1973
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	466.39661

Minimum	0
Maximum	2456
Zeros	19070
Zeros (%)	17.4%
Negative	0
Negative (%)	0.0%
Memory size	856.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	78
median	347
Q3	752
95-th percentile	1366
Maximum	2456
Range	2456
Interquartile range (IQR)	674

Descriptive statistics

Standard deviation	450.66673
Coefficient of variation (CV)	0.96627359
Kurtosis	0.073224389
Mean	466.39661
Median Absolute Deviation (MAD)	310
Skewness	0.92184684
Sum	51143187
Variance	203100.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19070	17.4%
37	1119	1.0%
113	763	0.7%
103	689	0.6%
112	663	0.6%
333	607	0.6%
111	554	0.5%
78	553	0.5%
104	448	0.4%
109	428	0.4%
Other values (1963)	84762	77.3%

Value	Count	Frequency (%)
0	19070	17.4%
1	203	0.2%
2	123	0.1%
3	77	0.1%
4	40	< 0.1%
5	51	< 0.1%
6	53	< 0.1%
7	49	< 0.1%
8	55	0.1%
9	19	< 0.1%

Value	Count	Frequency (%)
2456	1	< 0.1%
2276	1	< 0.1%
2243	1	< 0.1%
2232	3	< 0.1%
2194	3	< 0.1%
2158	2	< 0.1%
2157	1	< 0.1%
2155	1	< 0.1%
2154	1	< 0.1%
2151	3	< 0.1%

MMS_Flagged
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	103323
1	6333

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring characters

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	103323	94.2%
1	6333	5.8%

Multiple_Issues
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

1	101853
2	7683
3	120

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	2
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	101853	92.9%
2	7683	7.0%
3	120	0.1%

New_Patient_High_Value
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	107922
1	1734

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Most occurring characters

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	107922	98.4%
1	1734	1.6%

Peak_Hours_Rejection
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	71641
1	38015

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring characters

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	71641	65.3%
1	38015	34.7%

Weekend_Rejection
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	85197
1	24459

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring characters

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	85197	77.7%
1	24459	22.3%

is_anomaly
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.1 MiB

0	77830
1	31826

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	109656
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Most occurring characters

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109656	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	77830	71.0%
1	31826	29.0%

Interactions

Correlations

	DAW_Required	DayOfMonth_AtEntry	DayOfWeek_AtEntry	High_Value_Rx	HourOfDay_AtEntry	InsuranceCategory	Insurance_Coverage_Ratio	IsNewPatient	IsRefill	Is_Weekend	MMS_Flag	MMS_Flagged	Multiple_Issues	New_Patient_High_Value	Off_Hours_Entry	PatientTenureDays	PatientVisitFrequency	PeakHoursIndicator_AtEntry	Peak_Hours_Rejection	PrescriptionsPerStaff_AtEntry	Price_vs_Total_Ratio	Rx_Days_Supply_Filed	Rx_Is_non_Rx?	Rx_PRN?	Rx_Quantity_Filled	Rx_Refills_Remaining	Rx_RxEntered_By	Rx_TotalInsPaid	Rx_TotalRxAmount	Rx_Total_Price	StaffVolume_AtEntry	Time_Category	Weekend_Rejection	Zero_Insurance_Payment	is_anomaly
DAW_Required	1.000	0.021	0.009	0.028	0.043	0.017	0.009	0.027	0.006	0.000	0.009	0.009	0.491	0.002	0.040	0.017	0.007	0.007	0.007	0.034	0.000	0.021	0.000	0.020	0.010	0.037	0.068	0.011	0.002	0.002	0.024	0.042	0.000	0.012	0.012
DayOfMonth_AtEntry	0.021	1.000	-0.113	0.112	0.106	0.050	-0.068	0.352	0.267	0.110	0.057	0.057	0.044	0.026	0.199	0.122	0.059	0.181	0.181	-0.114	0.076	0.043	0.011	0.008	0.050	-0.056	0.203	-0.053	-0.046	0.069	-0.122	0.127	0.110	0.133	0.139
DayOfWeek_AtEntry	0.009	-0.113	1.000	0.056	-0.081	0.038	0.101	0.185	0.109	1.000	0.040	0.040	0.030	0.022	0.192	-0.101	-0.002	0.142	0.142	0.079	-0.106	-0.045	0.008	0.000	-0.056	0.083	0.200	0.089	0.082	-0.090	0.107	0.122	1.000	0.096	0.070
High_Value_Rx	0.028	0.112	0.056	1.000	0.153	0.025	0.256	0.143	0.025	0.015	0.052	0.052	0.059	0.221	0.094	0.162	0.074	0.023	0.023	0.170	0.004	0.070	0.009	0.012	0.035	0.029	0.138	0.052	0.033	0.034	0.136	0.097	0.015	0.246	0.085
HourOfDay_AtEntry	0.043	0.106	-0.081	0.153	1.000	0.105	-0.134	0.349	0.293	0.114	0.103	0.103	0.078	0.041	0.995	0.096	-0.184	0.768	0.768	-0.217	0.155	0.219	0.010	0.004	0.236	-0.118	0.416	-0.132	-0.110	0.147	-0.383	0.960	0.114	0.232	0.160
InsuranceCategory	0.017	0.050	0.038	0.025	0.105	1.000	0.190	0.103	0.113	0.002	0.674	0.674	0.428	0.078	0.136	0.097	0.050	0.035	0.035	0.077	0.006	0.123	0.000	0.000	0.020	0.007	0.122	0.000	0.013	0.013	0.060	0.097	0.002	0.280	0.043
Insurance_Coverage_Ratio	0.009	-0.068	0.101	0.256	-0.134	0.190	1.000	0.210	0.022	0.015	0.077	0.077	0.052	0.022	0.220	-0.303	-0.042	0.028	0.028	0.366	-0.448	-0.079	0.000	0.000	-0.167	0.239	0.091	0.873	0.689	-0.046	0.363	0.126	0.015	0.952	0.086
IsNewPatient	0.027	0.352	0.185	0.143	0.349	0.103	0.210	1.000	0.126	0.006	0.081	0.081	0.085	0.298	0.190	0.487	0.144	0.072	0.072	0.372	0.000	0.182	0.011	0.004	0.008	0.040	0.350	0.013	0.007	0.007	0.258	0.208	0.006	0.197	0.151
IsRefill	0.006	0.267	0.109	0.025	0.293	0.113	0.022	0.126	1.000	0.014	0.065	0.065	0.061	0.089	0.162	0.091	0.278	0.160	0.160	0.174	0.003	0.201	0.004	0.000	0.013	0.002	0.310	0.022	0.013	0.013	0.174	0.164	0.014	0.021	0.009
Is_Weekend	0.000	0.110	1.000	0.015	0.114	0.002	0.015	0.006	0.014	1.000	0.001	0.001	0.003	0.000	0.032	0.052	0.000	0.033	0.033	0.135	0.000	0.009	0.002	0.000	0.000	0.007	0.121	0.004	0.000	0.000	0.136	0.039	1.000	0.013	0.016
MMS_Flag	0.009	0.057	0.040	0.052	0.103	0.674	0.077	0.081	0.065	0.001	1.000	1.000	0.895	0.014	0.095	0.083	0.039	0.021	0.021	0.081	0.000	0.118	0.006	0.000	0.026	0.003	0.144	0.002	0.000	0.000	0.063	0.095	0.001	0.058	0.035
MMS_Flagged	0.009	0.057	0.040	0.052	0.103	0.674	0.077	0.081	0.065	0.001	1.000	1.000	0.895	0.014	0.095	0.083	0.039	0.021	0.021	0.081	0.000	0.118	0.006	0.000	0.026	0.003	0.144	0.002	0.000	0.000	0.063	0.095	0.001	0.058	0.035
Multiple_Issues	0.491	0.044	0.030	0.059	0.078	0.428	0.052	0.085	0.061	0.003	0.895	0.895	1.000	0.015	0.103	0.057	0.021	0.022	0.022	0.062	0.000	0.084	0.006	0.008	0.017	0.013	0.100	0.018	0.009	0.009	0.047	0.072	0.003	0.058	0.036
New_Patient_High_Value	0.002	0.026	0.022	0.221	0.041	0.078	0.022	0.298	0.089	0.000	0.014	0.014	0.015	1.000	0.030	0.141	0.042	0.015	0.015	0.022	0.000	0.034	0.000	0.000	0.000	0.006	0.111	0.064	0.042	0.041	0.021	0.041	0.000	0.018	0.012
Off_Hours_Entry	0.040	0.199	0.192	0.094	0.995	0.136	0.220	0.190	0.162	0.032	0.095	0.095	0.103	0.030	1.000	0.237	0.053	0.347	0.347	0.405	0.000	0.208	0.006	0.004	0.013	0.031	0.837	0.014	0.007	0.007	0.439	0.995	0.032	0.209	0.113
PatientTenureDays	0.017	0.122	-0.101	0.162	0.096	0.097	-0.303	0.487	0.091	0.052	0.083	0.083	0.057	0.141	0.237	1.000	0.141	0.059	0.059	-0.387	0.467	0.131	0.012	0.009	0.151	-0.257	0.170	-0.237	-0.266	0.428	-0.361	0.144	0.052	0.202	0.176
PatientVisitFrequency	0.007	0.059	-0.002	0.074	-0.184	0.050	-0.042	0.144	0.278	0.000	0.039	0.039	0.021	0.042	0.053	0.141	1.000	0.100	0.100	0.052	0.059	-0.352	0.031	0.000	-0.362	0.010	0.059	0.006	-0.027	-0.010	0.099	0.046	0.000	0.052	0.057
PeakHoursIndicator_AtEntry	0.007	0.181	0.142	0.023	0.768	0.035	0.028	0.072	0.160	0.033	0.021	0.021	0.022	0.015	0.347	0.059	0.100	1.000	1.000	0.167	0.000	0.058	0.001	0.000	0.004	0.026	0.591	0.000	0.000	0.000	0.216	0.607	0.033	0.027	0.018
Peak_Hours_Rejection	0.007	0.181	0.142	0.023	0.768	0.035	0.028	0.072	0.160	0.033	0.021	0.021	0.022	0.015	0.347	0.059	0.100	1.000	1.000	0.167	0.000	0.058	0.001	0.000	0.004	0.026	0.591	0.000	0.000	0.000	0.216	0.607	0.033	0.027	0.018
PrescriptionsPerStaff_AtEntry	0.034	-0.114	0.079	0.170	-0.217	0.077	0.366	0.372	0.174	0.135	0.081	0.081	0.062	0.022	0.405	-0.387	0.052	0.167	0.167	1.000	-0.499	-0.215	0.012	0.009	-0.244	0.330	0.598	0.286	0.252	-0.495	0.922	0.305	0.135	0.198	0.167
Price_vs_Total_Ratio	0.000	0.076	-0.106	0.004	0.155	0.006	-0.448	0.000	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.467	0.059	0.000	0.000	-0.499	1.000	0.211	0.000	0.000	0.227	-0.304	0.046	-0.318	-0.146	0.689	-0.481	0.000	0.000	0.008	0.000
Rx_Days_Supply_Filed	0.021	0.043	-0.045	0.070	0.219	0.123	-0.079	0.182	0.201	0.009	0.118	0.118	0.084	0.034	0.208	0.131	-0.352	0.058	0.058	-0.215	0.211	1.000	0.026	0.009	0.860	-0.126	0.085	-0.082	-0.052	0.254	-0.250	0.119	0.009	0.090	0.083
Rx_Is_non_Rx?	0.000	0.011	0.008	0.009	0.010	0.000	0.000	0.011	0.004	0.002	0.006	0.006	0.006	0.000	0.006	0.012	0.031	0.001	0.001	0.012	0.000	0.026	1.000	0.000	0.000	0.018	0.025	0.000	0.000	0.000	0.006	0.007	0.002	0.000	0.009
Rx_PRN?	0.020	0.008	0.000	0.012	0.004	0.000	0.000	0.004	0.000	0.000	0.000	0.000	0.008	0.000	0.004	0.009	0.000	0.000	0.000	0.009	0.000	0.009	0.000	1.000	0.000	0.002	0.015	0.000	0.000	0.000	0.000	0.002	0.000	0.000	0.010
Rx_Quantity_Filled	0.010	0.050	-0.056	0.035	0.236	0.020	-0.167	0.008	0.013	0.000	0.026	0.026	0.017	0.000	0.013	0.151	-0.362	0.004	0.004	-0.244	0.227	0.860	0.000	0.000	1.000	-0.145	0.012	-0.190	-0.151	0.231	-0.281	0.006	0.000	0.012	0.005
Rx_Refills_Remaining	0.037	-0.056	0.083	0.029	-0.118	0.007	0.239	0.040	0.002	0.007	0.003	0.003	0.013	0.006	0.031	-0.257	0.010	0.026	0.026	0.330	-0.304	-0.126	0.018	0.002	-0.145	1.000	0.076	0.193	0.176	-0.294	0.323	0.019	0.007	0.017	0.066
Rx_RxEntered_By	0.068	0.203	0.200	0.138	0.416	0.122	0.091	0.350	0.310	0.121	0.144	0.144	0.100	0.111	0.837	0.170	0.059	0.591	0.591	0.598	0.046	0.085	0.025	0.015	0.012	0.076	1.000	0.042	0.032	0.032	0.593	0.525	0.121	0.255	0.166
Rx_TotalInsPaid	0.011	-0.053	0.089	0.052	-0.132	0.000	0.873	0.013	0.022	0.004	0.002	0.002	0.018	0.064	0.014	-0.237	0.006	0.000	0.000	0.286	-0.318	-0.082	0.000	0.000	-0.190	0.193	0.042	1.000	0.862	0.170	0.290	0.008	0.004	0.016	0.002
Rx_TotalRxAmount	0.002	-0.046	0.082	0.033	-0.110	0.013	0.689	0.007	0.013	0.000	0.000	0.000	0.009	0.042	0.007	-0.266	-0.027	0.000	0.000	0.252	-0.146	-0.052	0.000	0.000	-0.151	0.176	0.032	0.862	1.000	0.330	0.251	0.000	0.000	0.009	0.005
Rx_Total_Price	0.002	0.069	-0.090	0.034	0.147	0.013	-0.046	0.007	0.013	0.000	0.000	0.000	0.009	0.041	0.007	0.428	-0.010	0.000	0.000	-0.495	0.689	0.254	0.000	0.000	0.231	-0.294	0.032	0.170	0.330	1.000	-0.474	0.000	0.000	0.009	0.005
StaffVolume_AtEntry	0.024	-0.122	0.107	0.136	-0.383	0.060	0.363	0.258	0.174	0.136	0.063	0.063	0.047	0.021	0.439	-0.361	0.099	0.216	0.216	0.922	-0.481	-0.250	0.006	0.000	-0.281	0.323	0.593	0.290	0.251	-0.474	1.000	0.330	0.136	0.153	0.127
Time_Category	0.042	0.127	0.122	0.097	0.960	0.097	0.126	0.208	0.164	0.039	0.095	0.095	0.072	0.041	0.995	0.144	0.046	0.607	0.607	0.305	0.000	0.119	0.007	0.002	0.006	0.019	0.525	0.008	0.000	0.000	0.330	1.000	0.039	0.209	0.116
Weekend_Rejection	0.000	0.110	1.000	0.015	0.114	0.002	0.015	0.006	0.014	1.000	0.001	0.001	0.003	0.000	0.032	0.052	0.000	0.033	0.033	0.135	0.000	0.009	0.002	0.000	0.000	0.007	0.121	0.004	0.000	0.000	0.136	0.039	1.000	0.013	0.016
Zero_Insurance_Payment	0.012	0.133	0.096	0.246	0.232	0.280	0.952	0.197	0.021	0.013	0.058	0.058	0.058	0.018	0.209	0.202	0.052	0.027	0.027	0.198	0.008	0.090	0.000	0.000	0.012	0.017	0.255	0.016	0.009	0.009	0.153	0.209	0.013	1.000	0.080
is_anomaly	0.012	0.139	0.070	0.085	0.160	0.043	0.086	0.151	0.009	0.016	0.035	0.035	0.036	0.012	0.113	0.176	0.057	0.018	0.018	0.167	0.000	0.083	0.009	0.010	0.005	0.066	0.166	0.002	0.005	0.005	0.127	0.116	0.016	0.080	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Rx RxEntered Date	DayOfWeek_AtEntry	DayOfMonth_AtEntry	HourOfDay_AtEntry	PeakHoursIndicator_AtEntry	PatientVisitFrequency	Rx_Days_Supply_Filed	Rx_Quantity_Filled	InsuranceCategory	Insurance_Carrier_Code	Insurance_Accepts_Assignments	Insurance_Billing_Receiver_ID	MMS_Flag	Rx_Total_Price	Rx_TotalInsPaid	Rx_TotalRxAmount	Rx_RxEntered_By	PrescriptionsPerStaff_AtEntry	StaffVolume_AtEntry	MainRejectCode	MainRejectDescription	Rx_Status	Rx_Hold_Rx_(Checkbox)	Rx_DAW	Rx_DUR_Entered_?	Rx_Refills_Remaining	Insurance_Coverage_Ratio	Price_vs_Total_Ratio	Zero_Insurance_Payment	High_Value_Rx	Time_Category	Off_Hours_Entry	IsRefill	PatientTenureDays	MMS_Flagged	Multiple_Issues	Peak_Hours_Rejection	is_anomaly
0	7/28/2020 8:34:00 PM	1	28	20	0	2	90	90.0	Private Insurance Carrier	MEDDAET	Y	MMISNYDOH	0	2.31	0.00	2.81	RS	27	17	10	M/I Patient Gender Code	B	0	N	N	0	0.000000	0.821772	1	0	Evening	1	1	447	0	1	0	0
1	2/25/2020 9:37:00 AM	1	25	9	0	1	90	90.0	Public Insurance Carrier	MMS286	Y	MMISNYDOH	1	5.25	0.00	5.75	RS	12	12	CA	Internal Code	B	0	N	N	0	0.000000	0.912885	1	0	Morning	0	0	153	1	2	0	0
2	2020-02-04 14:38:00	1	4	14	0	2	90	90.0	Public Insurance Carrier	MMS286	Y	MMISNYDOH	1	1624.68	1629.68	1629.68	RS	7	6	0	0	F	0	N	N	2	0.999999	0.996931	0	1	Afternoon	0	0	133	1	2	0	1
3	2020-08-05 15:42:00	2	5	15	0	1	90	180.0	Public Insurance Carrier	MMS286	Y	MMISNYDOH	1	2.09	0.00	2.59	RS	12	8	50	Non-Matched Pharmacy	B	0	N	N	1	0.000000	0.806638	1	0	Afternoon	0	0	153	1	2	0	0
4	2/25/2020 9:38:00 AM	1	25	9	0	2	0	0.0	Private Insurance Carrier	0	0	0	0	2.09	0.00	2.59	RS	12	12	50	Non-Matched Pharmacy	B	0	N	N	2	0.000000	0.806638	1	0	Morning	0	1	316	0	1	0	0
5	2020-08-05 15:42:00	2	5	15	0	1	17	180.0	Public Insurance Carrier	MMS286	Y	MMISNYDOH	1	2.68	0.00	3.18	RS	12	8	50	Non-Matched Pharmacy	B	0	N	N	1	0.000000	0.842502	1	0	Afternoon	0	0	153	1	2	0	0
6	2/25/2020 9:39:00 AM	1	25	9	0	2	0	0.0	Private Insurance Carrier	0	0	0	0	2.68	0.00	3.18	RS	12	12	50	Non-Matched Pharmacy	B	0	N	N	2	0.000000	0.842502	1	0	Morning	0	1	316	0	1	0	0
7	1/17/2020 11:35:00 AM	4	17	11	1	1	30	60.0	Private Insurance Carrier	AD1	Y	MMISNYDOH	0	838.68	833.68	843.68	HE	6	6	AC	Internal Code	F	H	N	N	1	0.988146	0.994072	0	1	Morning	0	0	52	0	1	1	1
8	3/17/2020 10:24:00 AM	1	17	10	0	1	90	90.0	Private Insurance Carrier	HF	Y	MMISNYDOH	0	60.87	0.00	60.87	RS	9	6	20	M/I Compound Code	B	0	N	N	1	0.000000	0.999984	1	1	Morning	0	0	172	0	1	0	0
9	2020-10-08 13:18:00	3	8	13	0	1	75	30.0	Private Insurance Carrier	MEDDAET	Y	MMISNYDOH	0	2440.44	2445.44	2445.44	RS	14	13	20	M/I Compound Code	F	0	N	N	2	1.000000	0.997955	0	1	Afternoon	0	1	303	0	1	0	1

	Rx RxEntered Date	DayOfWeek_AtEntry	DayOfMonth_AtEntry	HourOfDay_AtEntry	PeakHoursIndicator_AtEntry	PatientVisitFrequency	IsNewPatient	Rx_Days_Supply_Filed	Rx_Quantity_Filled	InsuranceCategory	Insurance_Carrier_Code	Insurance_Accepts_Assignments	Insurance_Billing_Receiver_ID	Rx_Total_Price	Rx_TotalInsPaid	Rx_TotalRxAmount	Rx_RxEntered_By	PrescriptionsPerStaff_AtEntry	StaffVolume_AtEntry	MainRejectCode	MainRejectDescription	Rx_Status	Rx_DAW	Rx_DUR_Entered_?	Rx_Refills_Remaining	Insurance_Coverage_Ratio	Price_vs_Total_Ratio	Zero_Insurance_Payment	Is_Weekend	Time_Category	IsRefill	PatientTenureDays	Multiple_Issues	Peak_Hours_Rejection	Weekend_Rejection	is_anomaly
109646	12/18/2024 2:21:00 PM	2	18	14	0	3	0	30	90.0	Private Insurance Carrier	B	Y	MMISNYDOH	12.84	12.84	12.84	EA	41	37	0	0	B	N	N	3	0.999922	0.999922	0	0	Afternoon	1	1164	1	0	0	1
109647	12/18/2024 4:12:00 PM	2	18	16	0	3	0	30	30.0	Private Insurance Carrier	11552	Y	MMISNYDOH	7.58	7.75	7.75	EA	41	4	0	0	B	N	Y	0	0.999871	0.977938	0	0	Afternoon	1	710	1	0	0	0
109648	12/20/2024 11:58:00 AM	4	20	11	1	1	0	15	15.0	Private Insurance Carrier	CAREMARK	Y	MMISNYDOH	0.21	0.21	0.21	EA	59	41	10	M/I Patient Gender Code	B	N	N	0	0.995261	0.995261	0	0	Morning	0	891	1	1	0	0
109649	12/23/2024 2:02:00 PM	0	23	14	0	1	0	30	60.0	Private Patient	C	Y	MMISNYDOH	14.50	0.00	14.83	EA	46	29	0	0	B	N	N	0	0.000000	0.977682	1	1	Afternoon	0	1133	1	0	1	1
109650	12/23/2024 4:41:00 PM	0	23	16	0	1	0	22	90.0	Private Patient	C	Y	MMISNYDOH	23.50	0.00	24.03	EA	46	17	50	Non-Matched Pharmacy	B	N	N	0	0.000000	0.977904	1	1	Afternoon	0	1018	1	0	1	0
109651	12/24/2024 8:55:00 AM	1	24	8	0	1	0	12	45.0	Private Insurance Carrier	AD1	Y	MMISNYDOH	27.00	0.00	27.00	FS	18	17	50	Non-Matched Pharmacy	B	N	N	0	0.000000	0.999963	1	0	Morning	0	596	1	0	0	0
109652	12/24/2024 11:07:00 AM	1	24	11	1	1	1	10	200.0	Private Insurance Carrier	BBBCS	Y	MMISNYDOH	27.12	0.00	27.73	FS	18	17	0	0	B	N	N	1	0.000000	0.977967	1	0	Morning	0	0	1	1	0	1
109653	12/27/2024 4:18:00 PM	4	27	16	0	1	0	30	30.0	Private Insurance Carrier	15581	Y	MMISNYDOH	1.24	0.00	1.54	EA	66	8	0	0	B	N	N	0	0.000000	0.804672	1	0	Afternoon	0	1414	1	0	0	0
109654	12/30/2024 11:23:00 AM	0	30	11	1	1	0	30	30.0	Private Patient	C	Y	MMISNYDOH	19.94	0.00	20.39	EA	35	27	10	M/I Patient Gender Code	B	N	N	0	0.000000	0.977882	1	1	Morning	0	348	1	1	1	0
109655	12/30/2024 11:23:00 AM	0	30	11	1	1	0	30	30.0	Private Patient	C	Y	MMISNYDOH	12.47	0.00	12.75	EA	35	27	CA	Internal Code	B	N	N	0	0.000000	0.977963	1	1	Morning	0	348	1	1	1	1

Duplicate rows

Most frequently occurring

	DayOfWeek_AtEntry	DayOfMonth_AtEntry	HourOfDay_AtEntry	PatientVisitFrequency	IsNewPatient	Rx_Days_Supply_Filed	Rx_Quantity_Filled	InsuranceCategory	Rx_Total_Price	Rx_TotalInsPaid	Rx_TotalRxAmount	Rx_RxEntered_By	PrescriptionsPerStaff_AtEntry	StaffVolume_AtEntry	Rx_Refills_Remaining	Insurance_Coverage_Ratio	Price_vs_Total_Ratio	Time_Category	Off_Hours_Entry	Multiple_Issues	# duplicates
1198	3	5	1	1	1	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	3	0.999989	0.00085	Night	1	1	963
1196	3	5	1	1	1	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	2	0.999989	0.00085	Night	1	1	885
1211	3	5	1	2	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	3	0.999989	0.00085	Night	1	1	517
1209	3	5	1	2	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	2	0.999989	0.00085	Night	1	1	483
1133	3	5	0	1	1	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	3	0.999989	0.00085	Night	1	1	312
1130	3	5	0	1	1	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	2	0.999989	0.00085	Night	1	1	263
1223	3	5	1	3	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	3	0.999989	0.00085	Night	1	1	180
1221	3	5	1	3	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	2	0.999989	0.00085	Night	1	1	179
1219	3	5	1	3	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	1	0.999989	0.00085	Night	1	1	170
1155	3	5	0	2	0	25	8.0	Private Insurance Carrier	0.08	94.08	94.08	MNK	5501	5501	3	0.999989	0.00085	Night	1	1	157

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values